using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    #region======ColumnSchema==========
       /*
          private string _ROWNID; public string ROWNID { get { return _ROWNID; } set { _ROWNID = value; OnPropertyChanged("ROWNID", value); } } //lENGth 0
          private string _MANDANT; public string MANDANT { get { return _MANDANT; } set { _MANDANT = value; OnPropertyChanged("MANDANT", value); } } //lENGth 2
          private string _INVDAT; public string INVDAT { get { return _INVDAT; } set { _INVDAT = value; OnPropertyChanged("INVDAT", value); } } //lENGth 10
          private string _DELDAT; public string DELDAT { get { return _DELDAT; } set { _DELDAT = value; OnPropertyChanged("DELDAT", value); } } //lENGth 10
          private string _INVOICE; public string INVOICE { get { return _INVOICE; } set { _INVOICE = value; OnPropertyChanged("INVOICE", value); } } //lENGth 15
          private string _VKPAUFKRS; public string VKPAUFKRS { get { return _VKPAUFKRS; } set { _VKPAUFKRS = value; OnPropertyChanged("VKPAUFKRS", value); } } //lENGth 2
          private string _VKPAUFLFD; public string VKPAUFLFD { get { return _VKPAUFLFD; } set { _VKPAUFLFD = value; OnPropertyChanged("VKPAUFLFD", value); } } //lENGth 6
          private string _VKPKOLL; public string VKPKOLL { get { return _VKPKOLL; } set { _VKPKOLL = value; OnPropertyChanged("VKPKOLL", value); } } //lENGth 5
          private string _VKPART; public string VKPART { get { return _VKPART; } set { _VKPART = value; OnPropertyChanged("VKPART", value); } } //lENGth 24
          private string _VAABEZ; public string VAABEZ { get { return _VAABEZ; } set { _VAABEZ = value; OnPropertyChanged("VAABEZ", value); } } //lENGth 30
          private string _CONSTRUCTION; public string CONSTRUCTION { get { return _CONSTRUCTION; } set { _CONSTRUCTION = value; OnPropertyChanged("CONSTRUCTION", value); } } //lENGth 200
          private string _COLOR; public string COLOR { get { return _COLOR; } set { _COLOR = value; OnPropertyChanged("COLOR", value); } } //lENGth 50
          private string _YARN; public string YARN { get { return _YARN; } set { _YARN = value; OnPropertyChanged("YARN", value); } } //lENGth 50
          private string _RATE; public string RATE { get { return _RATE; } set { _RATE = value; OnPropertyChanged("RATE", value); } } //lENGth 0
          private string _FACTORY; public string FACTORY { get { return _FACTORY; } set { _FACTORY = value; OnPropertyChanged("FACTORY", value); } } //lENGth 10
          private string _WARPDEN; public string WARPDEN { get { return _WARPDEN; } set { _WARPDEN = value; OnPropertyChanged("WARPDEN", value); } } //lENGth 0
          private string _WEFTDEN; public string WEFTDEN { get { return _WEFTDEN; } set { _WEFTDEN = value; OnPropertyChanged("WEFTDEN", value); } } //lENGth 0
          private string _MKUNDER; public string MKUNDER { get { return _MKUNDER; } set { _MKUNDER = value; OnPropertyChanged("MKUNDER", value); } } //lENGth 8
          private string _KDKNAME; public string KDKNAME { get { return _KDKNAME; } set { _KDKNAME = value; OnPropertyChanged("KDKNAME", value); } } //lENGth 8
          private string _VKPQTY; public string VKPQTY { get { return _VKPQTY; } set { _VKPQTY = value; OnPropertyChanged("VKPQTY", value); } } //lENGth 0
          private string _TYPE; public string TYPE { get { return _TYPE; } set { _TYPE = value; OnPropertyChanged("TYPE", value); } } //lENGth 20
          private string _CURRENCY; public string CURRENCY { get { return _CURRENCY; } set { _CURRENCY = value; OnPropertyChanged("CURRENCY", value); } } //lENGth 3
          private string _PREH; public string PREH { get { return _PREH; } set { _PREH = value; OnPropertyChanged("PREH", value); } } //lENGth 3
          private string _MDELQTY; public string MDELQTY { get { return _MDELQTY; } set { _MDELQTY = value; OnPropertyChanged("MDELQTY", value); } } //lENGth 0
          private string _YDELQTY; public string YDELQTY { get { return _YDELQTY; } set { _YDELQTY = value; OnPropertyChanged("YDELQTY", value); } } //lENGth 0
          private string _WEFTTOT; public string WEFTTOT { get { return _WEFTTOT; } set { _WEFTTOT = value; OnPropertyChanged("WEFTTOT", value); } } //lENGth 0
          private string _WARPUSAGE; public string WARPUSAGE { get { return _WARPUSAGE; } set { _WARPUSAGE = value; OnPropertyChanged("WARPUSAGE", value); } } //lENGth 0
          private string _WARPPRICE; public string WARPPRICE { get { return _WARPPRICE; } set { _WARPPRICE = value; OnPropertyChanged("WARPPRICE", value); } } //lENGth 0
          private string _WEFTUSAGE; public string WEFTUSAGE { get { return _WEFTUSAGE; } set { _WEFTUSAGE = value; OnPropertyChanged("WEFTUSAGE", value); } } //lENGth 0
          private string _WEFTPRICE; public string WEFTPRICE { get { return _WEFTPRICE; } set { _WEFTPRICE = value; OnPropertyChanged("WEFTPRICE", value); } } //lENGth 0
          private string _YARNVALUE; public string YARNVALUE { get { return _YARNVALUE; } set { _YARNVALUE = value; OnPropertyChanged("YARNVALUE", value); } } //lENGth 0
          private string _WARPED; public string WARPED { get { return _WARPED; } set { _WARPED = value; OnPropertyChanged("WARPED", value); } } //lENGth 0
          private string _WEFTED; public string WEFTED { get { return _WEFTED; } set { _WEFTED = value; OnPropertyChanged("WEFTED", value); } } //lENGth 0
          private string _DYEVALUE; public string DYEVALUE { get { return _DYEVALUE; } set { _DYEVALUE = value; OnPropertyChanged("DYEVALUE", value); } } //lENGth 0
          private string _MCOSTFIN; public string MCOSTFIN { get { return _MCOSTFIN; } set { _MCOSTFIN = value; OnPropertyChanged("MCOSTFIN", value); } } //lENGth 0
          private string _MCOSTPAKVV; public string MCOSTPAKVV { get { return _MCOSTPAKVV; } set { _MCOSTPAKVV = value; OnPropertyChanged("MCOSTPAKVV", value); } } //lENGth 0
          private string _MCOSTFADD; public string MCOSTFADD { get { return _MCOSTFADD; } set { _MCOSTFADD = value; OnPropertyChanged("MCOSTFADD", value); } } //lENGth 0
          private string _MPRICEAGENT; public string MPRICEAGENT { get { return _MPRICEAGENT; } set { _MPRICEAGENT = value; OnPropertyChanged("MPRICEAGENT", value); } } //lENGth 0
          private string _MCOSTAGENT; public string MCOSTAGENT { get { return _MCOSTAGENT; } set { _MCOSTAGENT = value; OnPropertyChanged("MCOSTAGENT", value); } } //lENGth 0
          private string _MPRICESHIP; public string MPRICESHIP { get { return _MPRICESHIP; } set { _MPRICESHIP = value; OnPropertyChanged("MPRICESHIP", value); } } //lENGth 0
          private string _MCOSTSHIP; public string MCOSTSHIP { get { return _MCOSTSHIP; } set { _MCOSTSHIP = value; OnPropertyChanged("MCOSTSHIP", value); } } //lENGth 0
          private string _MPRICEFLIGHT; public string MPRICEFLIGHT { get { return _MPRICEFLIGHT; } set { _MPRICEFLIGHT = value; OnPropertyChanged("MPRICEFLIGHT", value); } } //lENGth 0
          private string _MCOSTFLIGHT; public string MCOSTFLIGHT { get { return _MCOSTFLIGHT; } set { _MCOSTFLIGHT = value; OnPropertyChanged("MCOSTFLIGHT", value); } } //lENGth 0
          private string _MCOSTADD; public string MCOSTADD { get { return _MCOSTADD; } set { _MCOSTADD = value; OnPropertyChanged("MCOSTADD", value); } } //lENGth 0
          private string _MCOSTUNIT; public string MCOSTUNIT { get { return _MCOSTUNIT; } set { _MCOSTUNIT = value; OnPropertyChanged("MCOSTUNIT", value); } } //lENGth 0
          private string _RMBPRICE; public string RMBPRICE { get { return _RMBPRICE; } set { _RMBPRICE = value; OnPropertyChanged("RMBPRICE", value); } } //lENGth 0
          private string _MCOSTGROSS; public string MCOSTGROSS { get { return _MCOSTGROSS; } set { _MCOSTGROSS = value; OnPropertyChanged("MCOSTGROSS", value); } } //lENGth 0
          private string _MCOSTNET; public string MCOSTNET { get { return _MCOSTNET; } set { _MCOSTNET = value; OnPropertyChanged("MCOSTNET", value); } } //lENGth 0
          private string _COSTTOT; public string COSTTOT { get { return _COSTTOT; } set { _COSTTOT = value; OnPropertyChanged("COSTTOT", value); } } //lENGth 0
          private string _COSTTOTW; public string COSTTOTW { get { return _COSTTOTW; } set { _COSTTOTW = value; OnPropertyChanged("COSTTOTW", value); } } //lENGth 0
          private string _STAFF; public string STAFF { get { return _STAFF; } set { _STAFF = value; OnPropertyChanged("STAFF", value); } } //lENGth 20
          private string _COMMISSION; public string COMMISSION { get { return _COMMISSION; } set { _COMMISSION = value; OnPropertyChanged("COMMISSION", value); } } //lENGth 20
          private string _NEWART; public string NEWART { get { return _NEWART; } set { _NEWART = value; OnPropertyChanged("NEWART", value); } } //lENGth 20
          private string _PRICE; public string PRICE { get { return _PRICE; } set { _PRICE = value; OnPropertyChanged("PRICE", value); } } //lENGth 0
          private string _INVVALUE; public string INVVALUE { get { return _INVVALUE; } set { _INVVALUE = value; OnPropertyChanged("INVVALUE", value); } } //lENGth 0
          private string _RMBVALUE; public string RMBVALUE { get { return _RMBVALUE; } set { _RMBVALUE = value; OnPropertyChanged("RMBVALUE", value); } } //lENGth 0
          private string _REMARK; public string REMARK { get { return _REMARK; } set { _REMARK = value; OnPropertyChanged("REMARK", value); } } //lENGth 200
          private string _PRODVALUE; public string PRODVALUE { get { return _PRODVALUE; } set { _PRODVALUE = value; OnPropertyChanged("PRODVALUE", value); } } //lENGth 0
          private string _OTHERSVALUE; public string OTHERSVALUE { get { return _OTHERSVALUE; } set { _OTHERSVALUE = value; OnPropertyChanged("OTHERSVALUE", value); } } //lENGth 0
          private string _NM1; public string NM1 { get { return _NM1; } set { _NM1 = value; OnPropertyChanged("NM1", value); } } //lENGth 0
          private string _NM2; public string NM2 { get { return _NM2; } set { _NM2 = value; OnPropertyChanged("NM2", value); } } //lENGth 0
          private string _NM3; public string NM3 { get { return _NM3; } set { _NM3 = value; OnPropertyChanged("NM3", value); } } //lENGth 0
          private string _NM4; public string NM4 { get { return _NM4; } set { _NM4 = value; OnPropertyChanged("NM4", value); } } //lENGth 0
          private string _NM5; public string NM5 { get { return _NM5; } set { _NM5 = value; OnPropertyChanged("NM5", value); } } //lENGth 0
          private string _CHAR1; public string CHAR1 { get { return _CHAR1; } set { _CHAR1 = value; OnPropertyChanged("CHAR1", value); } } //lENGth 20
          private string _CHAR2; public string CHAR2 { get { return _CHAR2; } set { _CHAR2 = value; OnPropertyChanged("CHAR2", value); } } //lENGth 20
          private string _CHAR3; public string CHAR3 { get { return _CHAR3; } set { _CHAR3 = value; OnPropertyChanged("CHAR3", value); } } //lENGth 20
          private string _CHAR4; public string CHAR4 { get { return _CHAR4; } set { _CHAR4 = value; OnPropertyChanged("CHAR4", value); } } //lENGth 20
          private string _CHAR5; public string CHAR5 { get { return _CHAR5; } set { _CHAR5 = value; OnPropertyChanged("CHAR5", value); } } //lENGth 20
          private string _NEWUSER; public string NEWUSER { get { return _NEWUSER; } set { _NEWUSER = value; OnPropertyChanged("NEWUSER", value); } } //lENGth 8
          private string _NEWTIME; public string NEWTIME { get { return _NEWTIME; } set { _NEWTIME = value; OnPropertyChanged("NEWTIME", value); } } //lENGth 20
          private string _CHGUSER; public string CHGUSER { get { return _CHGUSER; } set { _CHGUSER = value; OnPropertyChanged("CHGUSER", value); } } //lENGth 8
          private string _CHGTIME; public string CHGTIME { get { return _CHGTIME; } set { _CHGTIME = value; OnPropertyChanged("CHGTIME", value); } } //lENGth 20
       */
       #endregion
    }
 

